var thai = {
	// insert
  submitUserComment: `insert into tb_comment set store_id=?,user_name=?,user_avatar=?,comment=?`,
  createStoreUserLog: `insert into tb_user_log set store_id=?,user_id=?`,

    // select
  getStoreViewNum: `select count(*) as count from tb_user_log where store_id=?`,
  getStoreCommentList: `select * from tb_comment where store_id=? and status=1 order by create_time desc`,
  getDistrictByCity: `select * from tb_city_district where city_index=? and status=1`,
  getStoreGoodById: `select * from tb_good where store_id=? order by create_time`,
  getStoreById: `select * from tb_store where store_id=?`,
  getStoreList: `select * from tb_store_list order by create_time desc`,
  getStoreListByType: `select * from tb_store_list as a where a.type=? and a.status=1`,
  getStoreListByAddress: `select * from tb_store_list as a where a.city_index=? and a.status=1 order by grade desc`

	// delete
	// update
}

module.exports = thai
